UCSF

Parameters Provided:

name.synonym = 1-(3-Pyridenyl)ethanone; 1-(3-Pyridinyl)ethanone; 3-Acetopyridine; 3-Acetylpyridine; 3-Pyridyl methyl ketone; AI3-50031; BRN 0107751; C7H7NO; EINECS 206-496-7; Ethanone, 1-(3-pyridinyl)-; FEMA No. 3424; Ketone, methyl 3-pyridyl; LS-2542; Methyl 3-pyridyl
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '1-(3-Pyridenyl)ethanone; 1-(3-Pyridinyl)ethanone; 3-Acetopyridine; 3-Acetylpyridine; 3-Pyridyl methyl ketone; AI3-50031; BRN 0107751; C7H7NO; EINECS 206-496-7; Ethanone, 1-(3-pyridinyl)-; FEMA No. 3424; Ketone, methyl 3-pyridyl; LS-2542; Methyl 3-pyridyl' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=1-%283-Pyridenyl%29ethanone%3B+1-%283-Pyridinyl%29ethanone%3B+3-Acetopyridine%3B+3-Acetylpyridine%3B+3-Pyridyl+methyl+ketone%3B+AI3-50031%3B+BRN+0107751%3B+C7H7NO%3B+EINECS+206-496-7%3B+Ethanone%2C+1-%283-pyridinyl%29-%3B+FEMA+No.+3424%3B+Ketone%2C+methyl+3-pyridyl%3B+LS-2542%3B+Methyl+3-pyridyl&filter.purchasability=all

Embed Link to Results